package com.purplesoft.zettl.DatabaseTables;

import android.provider.BaseColumns;

public class TblMeasures {

	public class Columns implements BaseColumns {
		// columns of table "tblMeasures"
		public static final String Measure = "Measure";
		public static final String MeasureShort = "MeasureShort";
		public static final String Min = "Min";
		public static final String Max = "Max";
		public static final String IncreaseBy = "IncreaseBy";
		public static final String Created = "Created";
		public static final String Modified = "Modified";
	}

	// table name
	public static final String tableName = "tblMeasures";

	// SQL command to create table "tblMeasures"
	public static final String createTable = "CREATE TABLE " + tableName + "("
			+ Columns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
			+ Columns.Measure + " TEXT, "
			+ Columns.MeasureShort + " TEXT, "
			+ Columns.Min + " REAL, "
			+ Columns.Max + " REAL, "
			+ Columns.IncreaseBy + " REAL, "
			+ Columns.Created + " TEXT, "
			+ Columns.Modified + " TEXT)";
}
